<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>SAN Switch - Slow Drain Analysis</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Slow Drain Devices</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Slow Drain Device Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Slow Drain Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Slow Drain Port Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg Tx Port Traffic</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Average Tx Traffic"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' K'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg Rx Port Traffic</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Average Rx Traffic"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' K'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Peak bbCreditZeroTx</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Peak bbCreditZeroTx"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' M'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Peak bbCreditZeroRx</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Peak bbCreditZeroRx"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' M'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Slow Drain Devices</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue/></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Top Slow Drain Devices" name="Combination Chart1" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis labelDisplayType="concat">
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									</style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Connected Device"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="bbCreditZeroTotal"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:500px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																					<v2_legend>
																																							<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style>
																																							<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>bbCreditZeroTx Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue/></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="bbCredit Trends" name="Combination Chart2">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis labelDisplayType="concat">
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																												<v2_labelControl displayFrequency="2"/></v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><dateTimeFormat pattern="MM/dd"/></dataFormat></style><sortList><sortItem refDataItem="Raw Date"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_area seriesType="stacked" borderColor="white" lineAreaShape="smooth">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="bbCreditZeroTx"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,###,###' M'"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:500px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										</v2_combinationChart>
																								</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>bbCreditZeroRx Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue/></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="bbCredit Trends" name="Combination Chart3">
							<v2_combinationTypeTooltips/>
							<v2_legend>
								<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
							<v2_commonAxis>
								<v2_ordinalAxis labelDisplayType="concat">
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
										</style>
									</v2_axisLabels>
								<v2_labelControl displayFrequency="2"/></v2_ordinalAxis>
							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><dateTimeFormat pattern="MM/dd"/></dataFormat></style><sortList><sortItem refDataItem="Raw Date"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_area seriesType="stacked" borderColor="white" lineAreaShape="smooth">
										<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="bbCreditZeroRx"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange>
										<v2_automaticRange/>
									</v2_axisRange>
									<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,###,###' M'"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
							</v2_topLeftAxis>
							<style>
								<CSS value="width:500px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
							<noDataHandler>
								<contents>
									<block>
										<contents>
											<textItem>
												<dataSource>
													<staticValue>No Data Available</staticValue>
												</dataSource>
												<style>
													<CSS value="padding:10px 18px;"/>
												</style>
											</textItem>
										</contents>
									</block>
								</contents>
							</noDataHandler>
							</v2_combinationChart>
					</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Slow Drain Device Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue/></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="Switch Perf" rowsPerPage="500">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Switch"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Switch"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Port"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Connection Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Connection Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Connected Device"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Connected Device"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Device Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Device Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Rx Traffic"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Rx Traffic"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tx Traffic"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Tx Traffic"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroTotal"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroTotal"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroRx"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroRx"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroTx"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroTx"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="bbCreditZeroMsTx"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="bbCreditZeroMsTx"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Class 3 Discard"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Class 3 Discard"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="bbCreditZeroTotal" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>3.11 SAN Switch - Slow Drain Analysis</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Switch Perf">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.switch_dimension.name as 'Port Switch',
dwh_performance.port_dimension.name as 'Port',
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTx',

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0)+ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTotal', 

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard'


FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk

WHERE dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx &gt; 1000000
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx &gt; 1000000 
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx &gt; 1

GROUP BY dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Port Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="bbCreditZeroTotal"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Port Switch" label="Switch"><expression>[SQL3].[Port Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL3].[Port]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL3].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL3].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL3].[Device Type]</expression></dataItem><dataItem name="Rx Traffic"><expression>[SQL3].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic"><expression>[SQL3].[Tx Traffic]</expression></dataItem><dataItem name="bbCreditZeroRx"><expression>[SQL3].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx"><expression>[SQL3].[bbCreditZeroTx]</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL3].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL3].[Class 3 Discard]</expression></dataItem><dataItem name="bbCreditZeroTotal"><expression>[SQL3].[bbCreditZeroTotal]</expression></dataItem><dataItem name="Slow Drain Device Count" aggregate="total"><expression>COUNT(DISTINCT [Connected Device] for Report)</expression></dataItem><dataItem name="Slow Drain Port Count" aggregate="total"><expression>COUNT(DISTINCT [Port] for Report)</expression></dataItem><dataItem name="Average Rx Traffic"><expression>average([Rx Traffic] for report)/1000</expression></dataItem><dataItem name="Average Tx Traffic"><expression>average([Tx Traffic] for report)/1000</expression></dataItem><dataItem name="Peak bbCreditZeroRx"><expression>maximum([bbCreditZeroRx] for report)/1000/1000</expression></dataItem><dataItem name="Peak bbCreditZeroTx"><expression>maximum([bbCreditZeroTx] for report)/1000/1000</expression></dataItem></selection>
		</query><query name="Top Slow Drain Devices">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.switch_dimension.name as 'Port Switch',
dwh_performance.port_dimension.name as 'Port',
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTx',

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0)+ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTotal', 

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard'


FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk

WHERE dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx &gt; 1000000
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx &gt; 1000000 
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx &gt; 1

GROUP BY dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name

ORDER BY (dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx+dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx) DESC LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Port Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="bbCreditZeroTotal"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Port Switch"><expression>[SQL4].[Port Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL4].[Port]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL4].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL4].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL4].[Device Type]</expression></dataItem><dataItem name="Rx Traffic"><expression>[SQL4].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic"><expression>[SQL4].[Tx Traffic]</expression></dataItem><dataItem name="bbCreditZeroRx"><expression>[SQL4].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx"><expression>[SQL4].[bbCreditZeroTx]</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL4].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL4].[Class 3 Discard]</expression></dataItem><dataItem name="bbCreditZeroTotal" aggregate="maximum"><expression>[SQL4].[bbCreditZeroTotal]</expression></dataItem></selection>
		</query><query name="bbCredit Trends">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.switch_dimension.name as 'Port Switch',
dwh_performance.port_dimension.name as 'Port',
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx/1000/1000,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx/1000/1000,0) as 'bbCreditZeroTx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard',
DATE_FORMAT(dwh_performance.time_dimension.hourdatetime, '%b-%d') as 'Date',
dwh_performance.time_dimension.hourdatetime as 'Raw Date'


FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk

WHERE dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx &gt; 1000000
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx &gt; 1000000 
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx &gt; 1

GROUP BY dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name, dwh_performance.time_dimension.hourdatetime

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Port Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/><mdProjectedItem name="Date"/><mdProjectedItem name="Raw Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Port Switch"><expression>[SQL5].[Port Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL5].[Port]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL5].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL5].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL5].[Device Type]</expression></dataItem><dataItem name="Rx Traffic"><expression>[SQL5].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic"><expression>[SQL5].[Tx Traffic]</expression></dataItem><dataItem name="bbCreditZeroRx" aggregate="maximum"><expression>[SQL5].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx" aggregate="maximum"><expression>[SQL5].[bbCreditZeroTx]</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL5].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL5].[Class 3 Discard]</expression></dataItem><dataItem name="Date"><expression>[SQL5].[Date]</expression></dataItem><dataItem name="Raw Date"><expression>[SQL5].[Raw Date]</expression></dataItem></selection>
		</query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Raw Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Raw Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Usable Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Usable Change] &gt;0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 3"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 4"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 5"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Used Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Used Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 6"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Free Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Free Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles></report>